package com.cyf.db.mapper;

import com.cyf.db.bean.LocalAdminpara;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by hfy on 2017/8/16.
 */

public interface LocalAdminparaMapper {

    @Select("select * from local_adminpara where paraKey = #{paraKey} and parkingId = #{parkingId} order by localAdminparaId desc limit 0 , 1")
    LocalAdminpara getByParkingIdAndParaKey(@Param("parkingId") Integer parkingId, @Param("paraKey") String paraKey);

    // 获取需要发送统计费用的车场
    @Select("select parkingId from local_adminpara where paraKey = 'smsnoticewhether' and paraValue = '1' ")
    List<Integer> getNeedSmsNoticeParkingIds();
}
